{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["index","polynomial","quadratic","quotient","tangent","maxmin","polynomial (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"index","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"DIFFERENTIATION AND INTEGRATION"]
[1,"Differentiating polynomial functions"]
[2,"Differentiating quadratic functions - expand those brackets!"]
[3,"Differentiating a rational function - simplify first!"]
[4,"Finding equations of tangents to curves"]
[5,"Finding stationary points on a curve"]
[6,"Integrating polynomial functions"]
[null,"© Copyright 2004 S.A.Lomax, M.J.Nixon.  All Rights Reserved."]

{"sheet":"polynomial","index":1,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[10,11,11,11],[10,12,11,12],[10,7,11,7],[10,8,11,8],[10,9,11,9],[10,10,11,10],[3,15,9,15],[3,11,8,11],[3,2,8,2],[3,4,8,4],[3,16,9,16],[3,5,8,5],[3,6,8,6],[3,7,8,7],[3,8,8,8],[3,9,8,9],[10,2,11,2],[10,4,11,4],[10,6,11,6],[10,5,11,5],[3,13,9,13],[3,14,9,14],[3,10,8,10],[3,12,9,12],[3,3,8,3],[10,3,11,3]]}
[]
[null,null,"Differentiate the following function"]
[]
[null,null,"y =",{"$f":"1+INT(RAND()*9)","v":7},"x",{"$f":"5+INT(RAND()*6)","v":8},{"$f":"IF(B22=1,\"+\",\"-\")","v":"-"},{"$f":"1+INT(RAND()*10)","v":1},"x",{"$f":"1+INT(RAND()*4)","v":3},{"$f":"IF(C22=1,\"+\",\"-\")","v":"+"},{"$f":"11+INT(RAND()*10)","v":16}]
[]
[]
[]
[]
[]
[]
[null,"dy","=",{"$f":"D4*F4","v":56},{"$f":"IF(F4-1=0,\" \",\"x\")","v":"x"},{"$f":"IF(F4-1=0,\" \",IF(F4-1=1,\" \",F4-1))","v":7},{"$f":"G4","v":"-"},{"$f":"J4*H4","v":3},{"$f":"IF(J4-1=0,\" \",\"x\")","v":"x"},{"$f":"IF(J4-1=0,\" \",IF(J4-1=1,\" \",J4-1))","v":2}]
[null,"dx"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"ROUND(RAND(),0)","v":0},{"$f":"ROUND(RAND(),0)","v":1}]

{"sheet":"quadratic","index":2,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[10,3,11,4],[10,7,11,8],[3,3,8,3],[3,2,8,2],[3,5,8,5],[10,14,11,14],[10,9,11,9],[10,11,11,11],[10,12,11,12],[3,14,8,14],[10,2,11,2],[10,5,11,5],[10,6,11,6],[10,13,11,13],[3,10,8,10],[3,4,8,4],[3,11,8,11],[3,12,8,12],[3,13,8,13],[3,6,8,6],[3,7,8,7],[3,8,8,8],[3,9,8,9]]}
[]
[null,null,"Differentiate the following function"]
[]
[null,null,"y =","(",{"$f":"1+INT(RAND()*4)","v":4},"x",{"$f":"IF(B22=1,\"+\",\"-\")","v":"+"},{"$f":"1+INT(RAND()*9)","v":7},")","(",{"$f":"1+INT(RAND()*4)","v":3},"x",{"$f":"IF(C22=1,\"+\",\"-\")","v":"+"},{"$f":"1+INT(RAND()*9)","v":4},")"]
[]
[]
[]
[]
[]
[]
[null,"dy","=",{"$f":"E4*K4*2","v":24},null,"x",{"$f":"IF(F16<0,\"-\",IF(F16>0,\"+\",\"\"))","v":"+"},{"$f":"IF(F16=0,\"\",ABS(F16))","v":37}]
[null,"dx"]
[]
[]
[null,{"$f":"K4","v":3},{"$f":"M4","v":"+"},{"$f":"N4","v":4}]
[{"$f":"E4","v":4},{"$f":"B15*A16","v":12},null,{"$f":"IF(C15=\"+\",D15*A16,-D15*A16)","v":16},null,{"$f":"D16+B18","v":37}]
[{"$f":"G4","v":"+"}]
[{"$f":"H4","v":7},{"$f":"IF(A17=\"+\",A18*B15,-A18*B15)","v":21},null,{"$f":"A18*D15","v":28}]
[]
[]
[]
[null,{"$f":"ROUND(RAND(),0)","v":1},{"$f":"ROUND(RAND(),0)","v":1}]

{"sheet":"quotient","index":3,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[6,8,8,10],[10,12,11,13],[10,8,11,10],[10,2,11,4],[3,5,5,5],[3,6,5,6],[3,7,5,7],[3,8,5,8],[10,1,11,1],[10,5,11,5],[10,7,11,7],[10,6,11,6],[6,4,8,6],[6,7,8,7],[3,17,9,17],[3,13,9,13],[3,2,8,3],[10,11,11,11],[3,9,5,9],[3,10,5,10],[3,14,9,14],[3,15,9,15],[3,16,9,16],[3,4,5,4]]}
[]
[null,null,"Differentiate the following function"]
[]
[null,null,"y =",null,{"$f":"1+INT(RAND()*9)","v":2},"x",{"$f":"5+INT(RAND()*6)","v":6},{"$f":"IF(B22=1,\"+\",\"-\")","v":"+"},{"$f":"1+INT(RAND()*9)","v":6},"x",{"$f":"1+INT(RAND()*4)","v":3}]
[]
[]
[null,null,null,null,{"$f":"1+INT(RAND()*2)","v":1},{"$f":"1+INT(RAND()*9)","v":8},{"$f":"1+INT(RAND()*9)","v":9},"x",{"$f":"1+INT(RAND()*6)","v":2},{"$f":"5+INT(RAND()*6)","v":8},{"$f":"5+INT(RAND()*6)","v":5}]
[]
[]
[]
["dy","=",{"$f":"IF(C14=0,\"\",IF(AND(C14=1,NOT(E14=0)),\"\",IF(AND(C14=-1,NOT(E14=0)),\"-\",C14)))","v":8},null,null,{"$f":"IF(E14=0,\"\",IF(C14=0,\"\",\"x\"))","v":"x"},{"$f":"IF(E13=1,\"\",IF(C14=0,\"\",IF(E14=1,\"\",E14)))","v":3},{"$f":"IF(AND(C14=0,F15=\"+\"),\"\",F15)","v":"+"},{"$f":"IF(G14=0,\"\",IF(AND(G14=1,NOT(I14=0)),\"\",IF(AND(G14=-1,NOT(I14=0)),\"\",ABS(G14))))","v":6},null,null,{"$f":"IF(I14=0,\"\",IF(G14=0,\"\",\"x\"))","v":""},{"$f":"IF(I13=1,\"\",IF(G14=0,\"\",IF(I14=1,\"\",I14)))","v":""},{"$f":"IF(L13=1,\"\",IF(J14=0,\"\",IF(L14=1,\"\",L14)))","v":""}]
["dx"]
[null,null,{"$f":"E4/E7","v":2},"x",{"$f":"G4-I7","v":4},{"$f":"H4","v":"+"},{"$f":"I4/E7","v":6},"x",{"$f":"K4-I7","v":1}]
[null,null,{"$f":"E13*C13","v":8},"x",{"$f":"E13-1","v":3},{"$f":"F13","v":"+"},{"$f":"I13*G13","v":6},"x",{"$f":"I13-1","v":0}]
[null,null,null,null,"sign",{"$f":"IF($I$13=0,\"\",IF(AND($G$14<0,$F$14=\"-\"),\"+\",IF(AND($G$14<0,$F$14=\"+\"),\"-\",$F$14)))","v":"+"}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"ROUND(RAND(),0)","v":1},{"$f":"ROUND(RAND(),0)","v":1}]

{"sheet":"tangent","index":4,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[3,15,9,15],[3,11,8,11],[3,10,8,10],[3,12,9,12],[3,13,9,13],[3,9,8,9],[11,9,11,10],[10,6,10,7],[10,9,10,10],[11,0,11,2],[11,5,11,6],[3,14,9,14],[1,4,1,6],[3,2,8,3],[3,4,8,4],[10,0,10,2],[3,16,9,16],[3,5,8,5],[3,6,8,6],[3,7,8,7],[3,8,8,8]]}
[null,"Find the equation of the tangent to the curve at x =",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(INT(RAND()*3))","v":0}]
[]
[]
[null,null,"y =",null,"x",{"$f":"3+INT(RAND()*3)","v":4},{"$f":"IF(B22=1,\"+\",\"-\")","v":"+"},{"$f":"2+INT(RAND()*8)","v":7},"x",{"$f":"1+INT(RAND()*2)","v":1},{"$f":"IF(C22=1,\"+\",\"-\")","v":"+"},{"$f":"1+INT(RAND()*10)","v":6}]
[]
[]
[]
[]
[]
[]
["Gradient: ",null,null,null,{"$f":"F4*(O1^(F4-1))","v":0},{"$f":"G4","v":"+"},{"$f":"IF(J4-1=0,H4,H4*J4*(O1^(J4-1)))","v":7},null,"=",{"$f":"IF(F11=\"+\",E11+G11,E11-G11)","v":7}]
["Equation:",null,null,null,"y =",{"$f":"IF(J11=0,\"\",IF(J11=1,\"\",IF(J11=-1,\"-\",J11)))","v":7},null,{"$f":"IF(J11=0,\"\",\"x\")","v":"x"},{"$f":"IF(K17=0,\"\",IF(K17>0,\"-\",IF(J11=0,\"\",\"+\")))","v":"+"},{"$f":"IF(K17=0,\"\",ABS(K17))","v":6}]
[]
[null,null,null,"y","-","y1","=","m","x","-","x1"]
[null,null,null,"y","-",{"$f":"IF(AND(G4=\"+\",K4=\"+\"),(O1^F4)+(H4*(O1^J4))+L4,IF(AND(G4=\"+\",K4=\"-\"),(O1^F4)+(H4*(O1^J4))-L4,IF(AND(G4=\"-\",K4=\"+\"),(O1^F4)-(H4*(O1^J4))+L4,(O1^F4)-(H4*(O1^J4))-L4)))","v":6},"=",{"$f":"J11","v":7},"x","-",{"$f":"O1","v":0}]
[null,null,null,"y","-",{"$f":"F15","v":6},"=",{"$f":"H15","v":7},"x","-",{"$f":"H16*K15","v":0}]
[null,null,null,null,null,"y","=",{"$f":"H16","v":7},"x","-",{"$f":"K16-F16","v":-6}]
[]
[]
[]
[]
[null,{"$f":"ROUND(RAND(),0)","v":1},{"$f":"ROUND(RAND(),0)","v":1}]

{"sheet":"maxmin","index":5,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[3,16,8,16],[10,12,10,14],[11,12,11,14],[1,4,1,6],[3,10,8,10],[3,12,8,12],[3,13,8,13],[3,15,8,15],[3,2,8,3],[3,4,8,4],[3,14,8,14],[3,11,8,11],[3,5,8,5],[3,6,8,6],[3,7,8,7],[3,8,8,8],[3,9,8,9]]}
[null,null,"Find the stationary points on the curve below"]
[]
[]
[null,null,"y =",null,"x",3,"-",{"$f":"ABS(L14)","v":6},"x",2,"-",{"$f":"ABS(N14)","v":96},"x",{"$f":"IF(B22=0,\"+\",\"-\")","v":"-"},{"$f":"2+(2*INT(RAND()*40))","v":44}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"3+(3*INT(RAND()*5))","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"3+(3*INT(RAND()*5))","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"3+(3*INT(RAND()*5))","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"3+(3*INT(RAND()*5))","v":12}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"3+(3*INT(RAND()*5))","v":6}]
[]
[null,null,"Stationary points",null,null,null,null,null,"Minimum:",null,null,{"$f":"CONCATENATE(\"(\",C16)","v":"(8"},{"$f":"CONCATENATE(\", \",IF(N4=\"+\",(C16^3)-(H4*(C16^2))-(L4*C16)+O4,(C16^3)-(H4*(C16^2))-(L4*C16)-O4),\")\")","v":", -684)"}]
[null,null,null,null,null,null,null,null,"Maximum:",null,null,{"$f":"CONCATENATE(\"(\",E17)","v":"(-4"},{"$f":"CONCATENATE(\", \",IF(N4=\"+\",(E17^3)-(H4*(E17^2))-(L4*E17)+O4,(E17^3)-(H4*(E17^2))-(L4*E17)-O4),\")\")","v":", 180)"}]
[null,null,null,"3x","+",{"$f":"3+(3*INT(RAND()*5))","v":12},null,"y'",3,"x",2,{"$f":"D16+F14","v":-12},"x",{"$f":"F16","v":-96}]
[null,null,"x","3x2",null,{"$f":"F13","v":12},null,"y",null,"x",3,{"$f":"L13/2","v":-6},"x2",{"$f":"N13","v":-96},"x"]
[null,null,"-"]
[null,null,{"$f":"8+(2*INT(RAND()*3))","v":8},{"$f":"C16*-3","v":-24},null,{"$f":"F13*-C16","v":-96}]
[null,null,null,null,{"$f":"-F13/3","v":-4}]
[]
[]
[]
[]
[null,{"$f":"ROUND(RAND(),0)","v":1},{"$f":"ROUND(RAND(),0)","v":1}]

{"sheet":"polynomial (2)","index":6,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,10,11,10],[10,11,11,11],[10,12,11,12],[3,12,9,12],[3,13,9,13],[3,14,9,14],[3,10,8,10],[10,0,11,1],[10,7,11,7],[10,9,11,9],[10,8,11,8],[10,13,11,13],[10,14,11,14],[3,2,8,2],[3,3,8,3],[3,15,9,15],[3,4,8,4],[3,5,8,5],[3,6,8,6],[3,7,8,7],[3,8,8,8],[3,9,8,9],[3,11,9,11]]}
[]
[null,null,"Integrate the following function"]
[]
[null,null,"y =","x",{"$f":"2+INT(RAND()*10)","v":7},{"$f":"IF(B22=1,\"+\",\"-\")","v":"-"},{"$f":"1+INT(RAND()*10)","v":6},"x",{"$f":"3+INT(RAND()*4)","v":4},{"$f":"IF(C22=1,\"+\",\"-\")","v":"+"},{"$f":"11+INT(RAND()*10)","v":13}]
[]
[]
[]
[]
[]
[]
["Answer:",null,1,"x",{"$f":"E4+1","v":8},{"$f":"F4","v":"-"},{"$f":"IF(G4=I4+1,\"\",G4)","v":6},{"$f":"IF($E$4-1=0,\" \",\"x\")","v":"x"},{"$f":"I4+1","v":5},{"$f":"J4","v":"+"},{"$f":"K4","v":13},{"$f":"IF($I$4-1=0,\" \",\"x\")","v":"x"},"+","c"]
[null,null,{"$f":"E11","v":8},null,null,null,{"$f":"IF(G4=I4+1,\"\",I4+1)","v":5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"ROUND(RAND(),0)","v":0},{"$f":"ROUND(RAND(),0)","v":1}]